Download Oracle Database Program with PL-SQL.1z0-149.ExamTopics.2025-11-15.65q.vcex

Vendor: Oracle
Exam Code: 1z0-149
Exam Name: Oracle Database Program with PL/SQL
Date: Nov 15, 2025
File Size: 5 MB
Downloads: 3
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator
ProfExam Discount

Demo Questions

Question 1
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
  1. PACKAGES
  2. VARIABLES
  3. ANONYMOUS BLOCK
  4. TRIGGER BODY
  5. DATABASE LINKS
Correct answer: AB
Explanation:
AB: 5 - MostedAD: 3
AB: 5 - MostedAD: 3
Question 2
Which three are true about functions and procedures? (Choose three.)
  1. The ACCESSIBLE BY clause can be used only for procedures.
  2. In a function, every execution path must lead to a RETURN statement.
  3. Both can have only constants as actual parameters for IN mode parameters.
  4. Both can be invoked from within SQL statements.
  5. In a procedure the RETURN statement cannot specify an expression.
  6. In a function every RETURN statement must specify an expression.
Correct answer: BEF
Explanation:
BEF: 1 - Mosted
BEF: 1 - Mosted
Question 3
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
  1. PL/SQL code can be compiled and executed based on different versions of the operating system.
  2. PL/SQL code can be compiled and executed based on different versions of Oracle.
  3. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
  4. Conditional compilation is disabled by default.
  5. The PL/SQL compiler can conditionally include selected parts of a program.
Correct answer: BE
Question 4
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
  1. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
  2. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  3. A deterministic function's results always depend on the state of session variables.
  4. The NOCOPY hint asks the compiler to pass the actual parameters by value.
  5. A function is deterministic if it always returns the same result for a specific combination of input values.
  6. The PARALLEL_ENABLE clause can be specified for a nested function.
  7. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
Correct answer: BEG
Question 5
Which two are true about INDEX-BY tables? (Choose two.)
  1. The index can be integer or string.
  2. The index can be integer only.
  3. INDEX-BY table types can be created in PL/SQL blocks only.
  4. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
  5. INDEX-BY table types can be created with the CREATE TYPE statement.
Correct answer: AC
Explanation:
AC: 5 - MostedAD: 1
AC: 5 - MostedAD: 1
Question 6
Which statement is true about user-defined records?
  1. They can be returned from a function.
  2. Field types must match column types.
  3. The number of fields must match the number of columns in a table.
  4. Field names must match selected column names.
Correct answer: A
Explanation:
A: 7 - Mosted
A: 7 - Mosted
Question 7
Examine the structure of the ora1.depts table:
Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:
Which is true?
  1. DEP_VU must be manually recompiled to successfully run this code.
  2. It will run successfully producing a result of 4.
  3. It will result in an error because table depts has been altered.
  4. It will run successfully producing a result of 5.
Correct answer: B
Explanation:
B: 10 - MostedD: 1
B: 10 - MostedD: 1
Question 8
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
Correct answer: C
Explanation:
C: 17 - Mosted
C: 17 - Mosted
Question 9
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
  1. When using the RETURNING INTO clause, the data returned can be only single column or expression.
  2. The RETURNING INTO clause and bulk binds may not be used together.
  3. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
  4. The RETURNING INTO clause returns column values for rows affected by DML statements.
  5. The RETURNING clause can be used for remote or parallel deletes.
Correct answer: CD
Explanation:
CD: 9 - Mosted
CD: 9 - Mosted
Question 10
Which three are true about anonymous blocks and subprograms? (Choose three.)
  1. Named subprograms cannot be called from other packages.
  2. PROCEDURE subprograms can accept parameters.
  3. A FUNCTION subprogram must return one or more values.
  4. Anonymous blocks cannot use packaged variables.
  5. Named subprograms are stored in the database server.
  6. Anonymous blocks must always start with the Declare keyword.
  7. FUNCTION subprograms must be called and passed through one or more parameters.
Correct answer: BCE
Explanation:
BCE: 7 - Mosted
BCE: 7 - Mosted
Question 11
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
  1. Function based indexes remain usable when replacing the function on which the index depends.
  2. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
  3. This clause can be used only for procedures and functions.
  4. A function definition can be modified without dropping and re-creating it.
  5. Object privileges to execute a replaced function are retained by those users who had the privileges.
Correct answer: DE
Explanation:
DE: 6 - Mosted
DE: 6 - Mosted
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!